SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This charming 3-season home on beautiful 1158-acre Mascoma Lake has been lovingly cared for by the same family for over 50 years — and now it’s ready for its next chapter. Nestled on 0.71 private acres with 210 feet of pristine waterfront, this 3-bedroom, 4-bath retreat invites you to slow down and savor lakeside living. Whether you're floating in the peaceful waters, relaxing in the sunken spa within the detached sunroom, enjoying a sunset from the mahogany deck, or strolling down the quiet, tree-lined road, every moment here feels like a getaway. Listen to the sound of the loons and watch the eagles soar. Nature's beauty is right at your doorstep. A 42-foot aluminum dock with new thru-flow decking stretches into the deep water, ideal for boating, fishing, or simply soaking in the beauty of the surroundings. Cedar shake siding adds timeless appeal, while the whole-house standby generator offers convenience and peace of mind. Inside, floor-to-ceiling windows bring the lakefront views right into the living space, and thoughtful updates throughout provide comfort and function. Though currently used as a 3-season home, it holds the potential to be enjoyed year-round with a few modifications. Here, the days feel longer, the air is a little sweeter, and the lake feels like it’s all your own.
Description:Welcome to this beautifully crafted, retreat-style home set in a very private Hanover location. Surrounded by over 10 acres of scenic land with a pond and stream, this exceptional property offers remarkable privacy, natural beauty, and a peaceful connection to the outdoors. The home features open-concept living with a stunning great room with pocket doors, kitchen, and dining area, along with a first-floor primary suite complete with a spa-inspired bathroom. In total, the home offers three bedrooms and six bathrooms, as well as a studio-style living space within the home, providing flexible options for guests, creative use, or extended living. Meticulously maintained and thoughtfully upgraded, this is truly a special property. The second level includes two spacious bedrooms with private bathrooms, ample closet space, and a charming hidden “secret” room. Additional highlights include a large finished walk-out basement, cedar closet, generous storage areas, and a versatile bonus room. Enjoy mornings in the heated sunroom overlooking serene natural surroundings, and unwind in the hot tub while taking in peaceful woodland views. Beautifully landscaped grounds offer breathtaking scenery and frequent wildlife sightings. Conveniently located just 10 minutes from downtown Hanover and the hospital, this home combines privacy with accessibility. A truly unique and exceptional offering—this home is a must see. Assisted group showings will be held May 1 4-6, May 2 12-2, May 3 12-2 must RSVP. OFFER DEADLINE 6PM SUNDAY MAY 3RD
Description:Open House Saturday, June 6th 11 AM - 1 PM. Location is a priority, and opportunity awaits. Dream of this idyllic and most-coveted "walk to town" West-end neighborhood setting in Hanover—a peaceful retreat just moments from the village bustle. A former home to renowned American artist Varujan Boghosian, this modernized split-style home sits elevated from the neighborhood roads, perched atop a wonderful corner lot. Many recent quality updates have brought the home up to excellent standards, ready for its next chapter. The floor plan is attractive and appealing, offering a fun and exciting renovation opportunity. Expand the home's footprint through the garage or by adding an addition. Large Eastern facing windows allow for plentiful sunshine, accenting lovely hardwood flooring and a fireplace, framing an open living and dining area with vaulted ceilings. A lower-level, sunken living space offers versatility and connects to a 2-car direct-entry garage. The location sits perfectly adjacent to Nathan's Garden and the Connecticut River Trail, while offering an easy walk to Main Street of Hanover, Dartmouth College campus, Hanover High School, and a quick drive to Dartmouth Health.
Description:Set on lovely, landscaped grounds, this inviting Colonial offers space, charm and exceptional warmth throughout. The home's floor plan features a beautiful eat-in kitchen, a formal living room and dining room and a conveniently located comfortable family room with a gas fireplace and a den/office. Off the family room is a fabulous year round sunroom/screen porch that opens onto a private deck creating wonderful spaces for summer entertaining and relaxation. A large mudroom off the kitchen with a 3/4 bath, serves as a convenient entrance for snowy or rainy days. The second floor has 4 bedrooms, an office and 2 full baths providing plenty of space for family and guests. A final standout feature of this home is the finished basement with an expansive rec room, exercise room, laundry room and a convenient half bath. This home is a must see!!
Description:Don't miss out on this incredible opportunity to own a beautiful commercial/residential zoned property in a highly visible area of Hanover, NH. Ideallysituated right on Route 10 (Lyme Road), just minutes from downtown Hanover and within walking distance of the elementary and middle schools, this property features agorgeous post and beam building connected by a breezeway to an additional building, with plenty of parking. Constructed by the renowned Timberpeg builders, the mainbuilding offers 3 levels of finished space, including a vaulted ceiling entryway suffused with natural light, a suite of offices, most of which feature en-suite bathrooms, aspacious shared kitchen, and a media room. The smaller building is a versatile 2-story space, originally built as a squash court, but ripe for use as a yoga studio, retailspace, or apartments. The newer zoning status allows for 49% of the buildings to be converted into residential living space, opening up endless possibilities for a buyer.This property has been beautifully maintained and updated over time, including a high-efficiency pellet boiler to help reduce expenses and carbon footprint. Take advantage of this unique Hanover offering and bring your ideas!